<%-- 
    Document   : ViewBankLoan
    Created on : Nov 4, 2011, 3:13:11 AM
    Author     : home
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="Admin.Model.BankLoan,Admin.Model.Banks ,java.util.ArrayList" %>
<%@page  import="Admin.DAO.BankLoanDAO, Admin.DAO.BankDAO" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" type="text/css" media="screen, projection" href="menu.css" />
        <link rel="stylesheet" type="text/css" media="screen, projection" href="style.css" />
        <title>View Bank Loan</title>
    </head>
    <body>
     <div class="wrap1">
  <div class="wrap2">
                <div class="logo" style="height: 110px; padding-top:  0px; ">
                    <img src="img/logo.png"/> My Sweet Home ltd.
                </div>
    <div id="menu">
      <div class="menu">
        <ul>
          <li><span class="hlavny_"><a href="index.jsp">Home</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="ViewRealEstate.jsp">Real Estate</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="viewSeller.jsp">User</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="ViewPostHistory.jsp" >Post Histories</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="ViewBank.jsp">Banks</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="ViewDirectory.jsp">Directories</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="ViewFAQs.jsp">FAQ</a></span></li>
          <li><img src="img/divider2.png" alt="" /></li>
          <li><span class="hlavny_"><a href="ViewFeedback.jsp">Feedback</a></span></li>
        </ul>
      </div>
      <div class="info">
        <%
                if (request.getSession().getAttribute("admin") != null) {
                    String userEmail = request.getSession().getAttribute("admin").toString();
                    out.print("<h4 style=\"color:#FF3300\">Welcome, "+userEmail + "  <a href=\"../Logout\" onclick=\" return confirm('Are u sure?')\" > Logout </a></h4>  ");
                } else {
                    response.sendRedirect("adminLogin.jsp");
                }

        %> 
      </div>
      <div class="leftpanel">
          <div class="mn_header_left"></div>
        <div class="mn_header_center">Admin Management</div>
        <div class="mn_header_right"></div>
        <div class="mn_content_center"><a href="ViewBank.jsp"><br/>&nbsp; &nbsp; View Bank</a></div>
         <div class="mn_content_right"></div>
        <div class="mn_content_center"><a href="AddBankLoan.jsp"><br/>&nbsp; &nbsp; Add New</a></div>
         <div class="mn_content_right"></div>
        <div class="mn_content_center"><a href="ViewDirectory.jsp"><br/>&nbsp; &nbsp; View Directory</a></div>
        <div class="mn_content_right"></div>
        <div class="mn_content_center"><a href="ViewPostHistory.jsp"><br/>&nbsp; &nbsp; Post History</a></div>
        <div class="mn_content_right"></div>
        <div class="mn_content_center"><a href="ViewRealEstate.jsp"><br/>&nbsp; &nbsp; Real Estate</a></div>
        <div class="mn_content_right"></div>
        <div class="mn_content_center"><a href="ViewFAQs.jsp"><br/>&nbsp; &nbsp; FAQ</a></div>
        <div class="mn_content_right"></div>
        <div class="mn_content_center"><a href="ViewFeedback.jsp"><br/>&nbsp; &nbsp; Feedback</a></div>
        <div class="mn_content_right"></div>

        <div class="mn_footer_left"></div>
        <div class="mn_footer_content"></div>
        <div class="mn_footer_right"></div>
<!--        <div class="header">Admin Management</div>
        <ul id="categories">
          <li><a href="ViewBank.jsp">View Bank</a></li>
          <li><a href="AddBankLoan.jsp">Add New Bank Loan</a></li>
          <li><a href="ViewDirectory.jsp">View Directory</a></li>
          <li><a href="ViewPostHistory.jsp">View Post History</a></li>
          <li><a href="ViewRealEstate.jsp">View Real Estate</a></li>
          <li><a href="ViewFAQs.jsp">View FAQ</a></li>
          <li><a href="ViewFeedback.jsp">View Feedback</a></li>
        </ul>-->
         
      </div>
<div id="content">
                    <div id="ad_header_left"></div>
                    <div id="ad_header_center"></div>
                    <div id="ad_header_right"></div>
                    <div class="ad_content_center">
                         <form action="../getbankID" method="post">

          <select name="bankID">
                                                <%
                                                BankDAO bankDao = new BankDAO();
                                                 ArrayList<Banks> listBank = new ArrayList<Banks>();
                                                 listBank = bankDao.GetAll();


                                                    for(int i = 0; i<listBank.size();i++){
                                                        Banks objBank = listBank.get(i);
                                                        System.out.println("objBank.getBankID(): "+objBank.getBankID());
                                                %>
                                                <option value="<%=objBank.getBankID() %>">
                                                    <%=objBank.getBankName() %>
                                                </option>
                                                <% } %>

      </select> <input type="submit" name="Click" value="View"/> </form>
   <br/>
   <table align="center" width="90%" class="tb_con">
         <tr bgcolor="darkred" style="height: 30px;">
         <th scope="col" width="50"><span style="color: white;">ID</span></th>
        <th scope="col" width="100"><span style="color: white;">Name</span></th>
        <th scope="col" width="100"><span style="color: white;">Maximum</span></th>
        <th scope="col" width="100"><span style="color: white;">Minimum</span></th>
        <th scope="col" width="100"><span style="color: white;">Description</span></th>
        <th scope="col" width="100"><span style="color: white;">Duration</span></th>
        <th scope="col" width="100"><span style="color: white;">Status</span></th>


         </tr>

        <%
                     BankLoanDAO bankLoanDao = new BankLoanDAO();
                     BankLoan  bankloan = new BankLoan();


                    if (request.getParameter("bankID") != null) {
                        int bankID = Integer.parseInt(request.getParameter("bankID"));
                        bankloan = bankLoanDao.GetByBankID(bankID);

                        int bankLoanID = bankloan.getBankLoanId();

                        %>

                        <tr bgcolor="#000000">
                                <td><span style="color: white;">
                                <%=bankloan.getBankLoanId() %></span>
                                </td>

                                <td><span style="color: white;">
                                <%=bankloan.getBankLoanName() %></span>
                                </td>

                                 <td><span style="color: white;">
                                <%=bankloan.getMaximum() %></span>
                                </td>

                                 <td><span style="color: white;">
                                <%=bankloan.getMinimum() %></span>
                                </td>
                                 <td><span style="color: white;">
                                <%=bankloan.getLoanDescription() %></span>
                                </td>
                                 <td><span style="color: white;">
                                <%=bankloan.getDurationOfLoan() %></span>
                                </td>

                                <td><span style="color: white;">
                                <% if(bankloan.getBankLoanStatus()==1){
                                    out.print("Active");
                                }else{
                                    out.print("Inactive");
                                } %></span>
                                </td>
                                <td>
                                     <a href= "UpdateBankLoan.jsp?bankLoanID=<%=bankLoanID %>">
                                       Edit</a>
                                    |
                                    <a href="../deleteBankLoan?bankLoanID=<%=bankLoanID %>"
                                       onclick=" return confirm('Are u sure ?')" > Delete</a>
                                </td>
                                </tr>

         <%
                     }else
                     {
                        ArrayList<BankLoan> listBankLoan = bankLoanDao.GetAll();
                        if (listBankLoan.size() > 0) {
                            for (int i = 0; i < listBankLoan.size(); i++) {

                                bankloan = listBankLoan.get(i);
                                int bankloanID = bankloan.getBankLoanId();


        %>
        <tr bgcolor="#000000">
                                <td><span style="color: white;">
                                <%=bankloan.getBankLoanId() %></span>
                                </td>

                                <td><span style="color: white;">
                                <%=bankloan.getBankLoanName() %></span>
                                </td>

                                 <td><span style="color: white;">
                                <%=bankloan.getMaximum() %></span>
                                </td>

                                 <td><span style="color: white;">
                                <%=bankloan.getMinimum() %></span>
                                </td>
                                 <td><span style="color: white;">
                                <%=bankloan.getLoanDescription() %></span>
                                </td>
                                 <td><span style="color: white;">
                                <%=bankloan.getDurationOfLoan() %></span>
                                </td>

                                <td><span style="color: white;">
                                <% if(bankloan.getBankLoanStatus()==1){
                                    out.print("Active");
                                }else{
                                    out.print("Inactive");
                                } %></span>
                                </td>
                                <td>
                                     <a href= "UpdateBankLoan.jsp?bankLoanID=<%=bankloanID %>">
                                       Edit</a>
                                    |
                                    <a href="../deleteBankLoan?bankLoanID=<%=bankloanID %>"
                                       onclick=" return confirm('Are u sure ?')" > Delete</a>
                                </td>
                                </tr>
                                <% } } } %>

</table>
                    </div>
                    <div id="ad_footer_left"></div>
                    <div id="ad_footer_center"></div>
                    <div id="ad_footer_right"></div>
                </div>

                <div class="cleaner_with_height"> </div>
                <div class="text_"> <strong>My Sweet Home ltd.</strong><br />
                    <br />
                    212 Military Parkway<br />
                    Los Angeles, CA 94043  Telephone: +421 903 000 000<br />
                    E-mail: e-mail@domain.com<br />
                    ICQ: 000-000-000<br />
                    Skype: corporation1<br />
                    <br />
                </div>
     
    </div>
    </div>
<div class="info1" style="height: 80px;">
                                        <div style="display:inline; float:left;">&copy; 2011 <a href="index.jsp">mysweethome.com</a>. Design by <a href="">Group 106 </a>.</div>
                                        <div style="display:inline; float:right;"><a href="http://aptech.vn">Ha Noi - Aptech</a></div>
                                    </div>
  </div>
    </body>
</html>
